# coding:utf-8

import xlrd

excel = xlrd.open_workbook('study.xlsx')
#打开工作簿
book = excel.sheet_by_name('学生手册')
print(book)
#打开工作簿
book = excel.sheet_by_index(0)
print(book.name)

for i in excel.sheets():
    print(i.name)
#返回总行数
print(book.nrows)
#返回总列数
print(book.ncols)
#返回每行内容列表
for i in book.get_rows():
    content = []
    for j in i:
        content.append(j.value)
    print(content)


